Use this function to create, inquire upon and update data associated with a specific product at a specific site.
Many of the fields are populated automatically from the product category record.
Refer to documentation Implementation
Fields
The following fields are present on this tab :
|
The product categories are used to classify and filter the products according to their use. This step makes it possible to refine the selection prior to carrying out the adjustment process. This code is specified in the Product record to enable selections. |
|
  |
|
Product reference |
|
Enter or select a storage site at which the selected product is active. The Selection icon (magnifying glass) only suggests products that are referenced in the products-sites table. |
|
This field indicates the product management unit in which are expressed:
This information is always displayed, regardless of the transaction used. It cannot be modified. |
Close
Presentation
This tab is used to specify the different information necessary to the management of the product stock, such as:
Using the right button on the location field makes available the location occupation and the dedicated location occupation inquiries.
See also the setup of the labels for these locations in the Product category documentation.
Close
Fields
The following fields are present on this tab :
Stock management
|
Several management methods can be selected, which influence the management of stock quantities:
|
Packing
|
Update 8.0.0 and higher: |
|
This field is used to specify whether the stock must be displayed in the parcels (Lot, Serial number, Status, etc.) |
|
Code on 3 alphanumerical characters. Enter the packaging in which the product is to be delivered. |
|
It is the the number of products, expressed in sales units, that the package can contain. |
Stock parameters
|
The ABC category allows the classification of products with regard to their importance to the turnover or to the stock for example. |
|
this field is used to specify the stock count method for the products in the category. |
|
The stock issue mode can be defined at category level, then refined by site category.
Two parameters from the material tracking transaction are associated with the issue mode: upon material tracking, it is possible to filter the materials to be proposed for consumption in the transaction (« post consumption / immediate / all stock issue » in the materials tab in the tacking transaction). These parameters are:
|
Storage
|
The product can be managed in stock, with possible entry of a storage location based on the value assigned to this code. |
Recontrol/Expiration
|
The lead-time of the new control is used on stock receipt. It is used to calculated the new control date based on the reference date. It is entered in days or months. |
|
Scroll-down list used to determine the time unit (day or month) associated with the previous field. |
|
When a lot in stock reaches a new control date the system automatically changes its status based on the controls defined on the product record.
|
|
The quality control process for the product can be described via a technical record, to be chosen from the technical record table. These records contain text descriptions, but also a set of questions and answers used to carry out statistical analyses concerning the quality control results. |
|
The use-by date (UBD) coefficient can only be accessed when the two following conditions are met:
This coefficient is used to calculate, in calendar days, the use-by lead time, based on the shelf life defined at the product record level.
This UBD lead time is used to determine the use-by date of the product, based on its stock receipt date. For example :
Update 8.0.0 and higher: |
|
This field cannot be entered. It displays the use-by lead time calculated based on the UBD coefficient. |
|
This field cannot be entered. The UBD lead time is always expressed in calendar days. |
Grid Default locations
|
No help linked to this field. |
|
Default location type. According to the location type required by this product category, specify a default location type. It is possible to enter a code with a generic character or a code from the "locations types" table. If entered, the location type can be used in the entries, allocations and issues. |
|
Default location. According to the location type involved by this product category, specify the default location that will be used for stock movements. It is possible to enter a code with a generic character (*,#,!,?) or a code from the locations table. If the location is of a dedicated type, it is necessary to carry out an assignment to establish it for this product. If entered, the location can be used in the entries, allocations and issues. |
Quality
|
This code is used to define whether the product must be controlled on stock receipt.
|
|
If the quality control is periodic, then this field is used to enter the frequency of the controls. |
|
  |
|
  |
|
The quality control process for the product can be described via a technical record, to be chosen from the technical record table. These records contain text descriptions, but also a set of questions and answers used to carry out statistical analyses concerning the quality control results. |
|
Quality operator access |
Sampling
|
Two values exist to determine the sampling mode:
If "None" is selected, all the fields of the Sampling section cannot be accessed. |
|
This field indicates the general control level of products. The AFNOR standard defines three control levels. Level 2 : recommended by the AFNOR standard, is the regular level delivered by Sage.
|
|
Reminder: The Acceptable Quality Level is the quality index of the manufactured products. It requires to pick a certain quantity of samples on a group of finished products, according to the AFNOR NF X06-021 and X06-022 standards. The AQL mathematically guarantees a potential maximum number of defective products defined by a determined units number. The lots of products are rejected if the number of defective parts exceeds the norm. The AQL is calculated according to two criteria:
Select the AQL. When entering the sampling, the section "Sample" brings back the size of the rejection and the approval limit according to the quantity entered and the size of the sample. |
|
Field allowing the sampling target on two types:
|
Managers
|
Operator in charge of performing the production planning or product ordering. |
|
Buyer/Planner |
EU info
|
Bill of lading
|
This field displays the default value from the product category for use in Bill of lading. The value is controlled by the legislation and site groupings and is used when generating new bill of lading detail lines. You can also modify this field. |
|
As of update 8.0.0: This field displays the default value from the product category when creating new records and can be overwritten. The value entered in this field is used when generating new bill of lading detail lines. This field is available only if the activity code KUS - USA Localization and the USABOL - Bill of Lading parameter are set to "Yes". |
Close
Fields
The following fields are present on this tab :
Planning
|
The fixed horizon (in leadtime unit) is used in the calculation of the Master Production Schedule (MPS) and Material Requirements Planning (MRP). It can be used to freeze the production plan on a given period: the suggestions used to cover the shortages located within this horizon are transferred onto the first period beyond this horizon. These suggestions are subject to a specific marking in the MRP results and MPS results inquiries: in the Order column, the order code is followed by an asterisk (*). |
|
Planning horizon lead-time unit (weeks, fortnights or months). |
|
The request horizon, expressed in number of days, is used to calculate the projected stock: the available stock is calculated using the customer order book below this horizon, and the forecasts above this horizon. |
|
Request horizon lead-time unit (weeks, fortnights or months). |
|
Seasonality - This is an allocation curve used to create forecasts, based on a seasonality variation structure that can be parameterized. Seasonality curves are created in the seasonality table. |
|
The loss percentage corresponds to the production or storage loss. The production loss corresponds to the totaled loss generated for each routing operation. This percentage is taken into account in the material requirements planning and in the work order management. it is used to calculate the quantity to be reordered to obtain the quantity to cover the requirement. |
Reordering
|
Reorder mode selection:
|
|
For a periodic reorder mode, indicate here the number of calendar days between two reorders. |
|
The reorder policy is used to set up the calculation mode of suggestions in the MRP processing:
|
|
The coverage, expressed in weeks, is one of the MRP parameters. It makes it possible to work with changeable security and reorder lots depending on the order book or on the forecasts recorded during the coverage period. |
|
The suggestion type is used in the material requirements planning. It is used to define if the product has to be subject to:
|
|
When the suggestion is of the type inter-site, this field serves to indicate the supplier site from which the replenishment must be carried out. The inter-site suggestion is coupled with a requirement at the replenishment site.
|
|
The security stock is used in the material requirements planning. It features an additional stock implemented to be able to face a longer deadline to obtain stock or a request higher than the average request. |
|
The reorder treshold is used in the stock management on order. This is the stock level from which a reordering (or work order) is triggered. It is generally equal to the consumption sum during the reorder time, to which the security stock is added. |
|
The maximum stock is taken into account in the reorder calculations. |
|
Minimum reorder quantity
|
|
Lot size
|
|
  |
Lead times
|
Number of days corresponding to the production lead-time for a finished or semi-finished product. It is in general fixed for a given lot size, and is used to calculate the start date for the MRP suggestions. |
|
The declining coefficient (in percentage) of the reorder lead-time is used to calculate the start date of the suggestions in the MRP. It is used correct the reorder lead-time proportionally to the replenishment, when the planned or suggested quantity is higher than a lot: |
|
The quality control lead-time (in number of days) is used in MRP: It is inserted between the requirement date and the suggestion end date to take into account the time necessary to carry out the quality control. |
|
The multi-level lead-time is the total reorder lead-time of the product expressed in days. |
|
Number of days corresponding to:
It is in general fixed for a given lot size, and is used to calculate the start date for the MRP suggestions. |
|
Number of working days delay applicable for inventory control purposes. That is, the number of days before this product can be used, such as in a manufactured product, a purchase or before it can be shipped for a sale.
|
Parameters
|
The assignment rule is used to create a link between a requirement (sales order, material requirement, etc.) and a resource (work order, purchase order, etc.).
|
|
  |
Replanning
|
Indicator that is used to de-activate the replanning or orders in process for the product concerned. Works order: in process if at least one production tracking exists. Purchase order: in process if partially received. Warning : this parameter is taken into account of the corresponding parameter in the requirements calculation parameterisation has the value "According to product". |
Notes
|
  |
Close
Presentation
This tab displays a total of stock accumulations for the product on the inquired site: internal stock accumulations and loaned or sub-contracting stock accumulations externally assigned.
These quantities are detailed by status and by allocation status.
Close
Fields
The following fields are present on this tab :
Internal situation
|
The physical stock field is formatted according to the stock unit. |
|
  |
|
  |
|
  |
|
Rejected stock: this field is formatted according to the stock unit. |
|
  |
|
  |
|
  |
|
  |
|
  |
|
  |
|
  |
External situation
|
  |
|
  |
|
  |
|
  |
|
  |
|
  |
|
  |
|
In-transit stock corresponds to the stock total which has not been received yet on the current site and coming from an inter-site transfer. |
|
  |
|
Transferred stock corresponds to the stock total sent from current site to another site and which has not been received on ship-to site. |
|
  |
|
  |
BP stock situation
|
  |
|
  |
WIP
|
It is the replenishing stock count. |
|
Click this check box if the planning calculations should decrease quantities related to suspended transactions from the available stock. |
|
The stock in customer order corresponds to the customer order total quantity and the inter-site demands for the product, not yet delivered. |
Close
Presentation
This tab displays the statistical information concerning the stock entry and issue movements.
Close
Fields
The following fields are present on this tab :
Period
|
  |
|
  |
|
  |
|
Button used to access in display mode the history of the product-site totals. |
|
  |
Receipts
|
  |
|
  |
|
  |
|
  |
  |
|
  |
|
  |
|
  |
|
  |
Issues
|
  |
|
  |
|
  |
|
  |
|
  |
|
  |
|
  |
Close
Presentation
The information on the safety stock, the reorder threshold, the maximum stock and the economic lot can either be entered or calculated by the Statistical reordering. process. These data are summed up in this tab.
Close
Fields
The following fields are present on this tab :
Entry data
|
The security stock is used in the material requirements planning. It features an additional stock implemented to be able to face a longer deadline to obtain stock or a request higher than the average request. |
|
The reorder treshold is used in the stock management on order. This is the stock level from which a reordering (or work order) is triggered. It is generally equal to the consumption sum during the reorder time, to which the security stock is added. |
|
The maximum stock is taken into account in the reorder calculations. |
|
Minimum reorder quantity
|
Calculated data
|
  |
|
  |
|
  |
|
  |
Close
Presentation
In the case where the product is manufactured, this tab is available for entry. Specified here are the routes to suggest by default for the launch, cost calculation, load calculation processes.
Close
Fields
The following fields are present on this tab :
Routings
|
This routing is used in work order management. |
|
alternative selected must be authorized for the site, with a "Manufacturing" indicator ticked. Thealternative selected must be authorized for the site, with a ticked "Manufacturing" indicator. This is the alternative used in processings where there is no default alternative. |
|
The standard costs calculation determines the added value by the production, from the range specified here. The range selected must exist in the alternative authorized for the site, with a checked "manufacturing" indicator. |
|
alternative selected must be authorized for the site, with a "Cost" indicator ticked. Thealternative selected must be authorized for the site, with a ticked "Cost" indicator. It will be used as a default value for the cost calculation. |
|
At the end of the MPS calculation, a global charge calculation can be required from the routing specified here. Rough Cut Capacity Planning is the translation of the French abbreviation "PGC" (for "Planification Globale des Capacités"). The routing selected must exist in the alternative authorized for the site, with a checked "RCCP" indicator. |
|
alternative selected must be authorized for the site, with a "RCCP" indicator checked. Thealternative selected must be authorized for the site, with a checked "RCCP" indicator. This is the alternative used in processings where there is no default alternative. |
Parameters
|
This flag defines the blocking behavior for a shortage of the product with respect to the printing of the manufacturing folders and production tracking. |
|
This percentage defines the threshold being applied to automatically close the materials during production tracking. For instance, if the value is 95% and the material requirement is 200 UN, the system will suggest to close the material if the consumed quantity is greater than or equal to 190 UN. |
|
This parameter supports two management modes for the losses incurred in the production release. |
Weighing
|
Access code used to restrict access to data for certain users. If the field is entered, only the users that have this access code in their profile can use this product in weighing... |
|
ISM record that will be used for this product. |
|
|
This field displays the percentage used to calculate the weight variance. You can only modify this field if the Setup level is set to BOM. If the Setup level is SHI record or Product-site, this value is based on the Product-sites setup. (GESITF) Note: This field is only available when the MWM - Weighing station activity code is active. |
|
  |
Close
Presentation
On this last tab, you can specify which Overheads code applies to the product and how the different product provisional costs have to be updated.
It specifies the valuation method used for this product.
Close
Fields
The following fields are present on this tab :
Valuation
|
|
|
The percentage of the quantity below which the adjusted amount will be distributed in two parts: remaining stock and the stock already issued. This percentage is compared with respect to the physical stock remaining and the global stock quantity produced by a WO. This is used to distribute the adjusted price amounts to the appropriate accounts. If this field is de-activated, the distribution is made without taking into account this limit. |
|
  |
Grid Overhead
|
This field is used to specify the overheads matching this entry type. |
|
Select an overhead code. Overhead codes are used as follows:
The overheads column that contains the formula or fixed rate to be used in the cost price calculation functions is defined by parameters. For standard cost calculations the OVECOLSTD - Standard calc overhead column parameter (GPA chapter, COS group) applies. You can modify the column to be applied before running the calculation. |
|
This field is used to select the calculation type.
|
Cost calculation
|
This field is used to enter the cost update indicator (for each type):
|
|
  |
|
  |
|
  |
Landed costs
|
This button opens a window used to enter the landed costs for each product-supplier linked to the site. |
Price
|
Displayed parameter that can neither be entered nor modified. |
|
  |
|
Displayed parameter that can neither be entered nor modified. |
|
  |
|
  |
|
  |
|
  |
|
This field is available for display but not for modification.
The following invoices are not taken into account:
Example:
|
|
Displayed parameter that can neither be entered nor modified. |
|
  |
|
Displayed parameter that can neither be entered nor modified. |
|
  |
|
Displayed parameter that can neither be entered nor modified. |
|
  |
|
Displayed parameter that can neither be entered nor modified. |
|
  |
Close
Presentation
Specify information on the stock count status of the current product-site, such as:
Also specified here, if necessary, the date of the next stock count, the number of stock counts having already taken place for the product at the site and the number of valid counts.
Finally, the Stock count specifications grid is used to give statistical information concerning each completed stock count.
Close
Fields
The following fields are present on this tab :
Counts
|
  |
|
  |
|
  |
|
  |
|
  |
|
  |
|
  |
|
  |
|
  |
Grid Count history
|
  |
|
  |
|
  |
|
  |
|
  |
|
  |
Close
Presentation
This tab displays logistics information.
Close
Fields
The following fields are present on this tab :
Allocation flows
|
When the product-site authorizes the management of locations, you can enter a preferred warehouse by type of flow. |
Issue flows
|
When the product-site authorizes the management of locations, you can enter a preferred warehouse by type of flow. |
Close
By default, the following reports are associated with this function :
ITMFORM : Product information by site
This can be changed using a different setup.
Click the Quote line action to view quotes for the product at the site.
Filters can be applied within the inquiry function to provide simple and fast access to a range of, or specific, quotes.
Click the Order line action to view sales orders for the product at the site.
Filters can be applied within the inquiry function to provide simple and fast access to a range of, or specific, orders.
Click the Delivery line action to view deliveries for the product from the site.
Filters can be applied within the inquiry function to provide simple and fast access to a range of, or specific, delivery numbers.
Click the Invoice line action to view sales invoices for the product at the site.
Filters can be applied within the inquiry function to provide simple and fast access to a range of, or specific, invoices.
Click the Demand line action to view purchase requests for the product for the site.
Filters can be applied within the inquiry function to provide simple and fast access to a range of, or specific, requests.
Click the Order line action to view purchase orders for the product for the site.
Filters can be applied within the inquiry function to provide simple and fast access to a range of, or specific, orders.
Click the Receipt line action to view purchase receipts for the product at the site.
Filters can be applied within the inquiry function to provide simple and fast access to a range of, or specific, receipts.
Click the Return line action to view the supplier returns for the product on the site.
Filters can be applied within the inquiry function to provide simple and fast access to a range of, or specific, returns.
Click the Invoice line action to view purchase invoices for the product for the site.
Filters can be applied within the inquiry function to provide simple and fast access to a range of, or specific, invoices.
Click the Material consumption action to track the material consumed for the product on the site.
Filters can be applied within the inquiry function to provide simple and fast access to a range of, or specific, tracking numbers.
Click the Cost price action to view production costs for the product at the site.
Click the Production cost history action to view the production cost prices for the product on the site.
Filters can be applied within the inquiry function to provide simple and fast access to a range of, or specific, dates.
Click the List of WOs action to view work order information, component information and operation details for the product at the site.
Filters can be applied within the inquiry function to provide simple and fast access to a range of, or specific, work orders.
In addition to the generic error messages, the following messages can appear during the entry :
The site entered (in creation) is not a warehouse. It cannot be used to create product-site records.
The route alternative selected is not authorized for the site or for the associated processing (Production, Cost, MRP, RCCP).
This message is displayed when the maximum stock is left at 0 and the reorder policy requires a 'maximum stock addition'.
Verify the coherence of these fields.
The routing version defined already exists for this product. Each major version and, if applicable, major plus minor version must be unique.
This message will be displayed if the routing already exists at the displayed site.
This message will be displayed if the routing already exists for the displayed product-site record.
The format of the routing version defined is incorrect. Please refer to the product record.